import openpyxl

myBook=openpyxl.load_workbook('成绩表.xlsx')
mySheet=myBook.active

for myRow in range(mySheet.max_row,1,-1):
	myRowSum=sum([myCell.value for myCell in mySheet[myRow][1:6]])
	if myRowSum<400:
		mySheet.delete_rows(myRow)

myBook.save('结果表-成绩表.xlsx')